Navicat provides all the tools you need to manage and navigate databases. Note that to start working with databases in Navicat you are to establish the connection (see Connection Settings).
Create Database
To create a database
- Double-click the connection to open in the navigation pane.
- Control-click the opened connection and choose
New Database.
or - Control-click any existing database and choose New Database.
- Fill in the required information:
Database Name
Set the name for a new database.
Default Character Set
The Character set specifies the default database character set.
Default Collation
The Collation specifies the default database collation.
Delete Database
To delete a database
- Control-click the database in the navigation pane and choose Delete Database.
- Confirm removing in the dialog window.
Open Database
To open a hidden database
- Double-click the connection to open in the navigation pane.
- Control-click the opened connection and choose Open Database.
- Enter the database name.
To open a database which shows in the navigation pane
- Double-click the database to open in the navigation pane.
or - Control-click the database and choose Open Database.
Close Database
To close a database
- Control-click the database in the navigation pane and choose Close Database.
Edit Database
To edit a database
- Control-click the database in the navigation pane and choose Database Properties.
Please notice that MySQL does not support renaming database through its interface at this moment.
Access the directory in which databases being stored. By default, all databases
store within a directory called data under MySQL Installation folder.
For example: /usr/local/mysql5/data.
Note: You must stop MySQL before you can rename the database.
See also:
Setting Advanced Database Properties
Related topic:
Advanced Settings